{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"Exercício 5.5 - Simulação"]
[]
[]
[null,"P(AvMotor/AvMotor)",null,null,0.17]
[null,"P(AvProg/AvProg)",null,null,0.5]
[]
[null,"Nº","Tipo",null,"Próxima ","      Custo","Reparação","        Nº Avarias"]
[null,"Avaria","Avaria","NPA","Avaria","Avaria","Acumulado","Motor","Programador"]
[null,0,"Motor",{"$f":"RAND()","v":0.26922549841697252},{"$f":"IF(C9=\"Motor\",IF(D9<$E$4,\"Motor\",\"Programador\"),IF(D9<$E$5,\"Programador\",\"Motor\"))","v":"Programador"},0,{"$f":"+F9","v":0},0,0]
[null,{"$f":"+B9+1","v":1},{"$f":"+E9","v":"Programador"},{"$f":"RAND()","v":0.9460988996025208},{"$f":"IF(C10=\"Motor\",IF(D10<$E$4,\"Motor\",\"Programador\"),IF(D10<$E$5,\"Programador\",\"Motor\"))","v":"Motor"},{"$f":"IF(C9=\"Motor\",IF(C10=\"Motor\",0,20),IF(C10=\"Programador\",0,55))","v":20},{"$f":"+G9+F10","v":20},{"$f":"IF(C10=\"Motor\",H9+1,H9)","v":0},{"$f":"IF(C10=\"Motor\",I9,I9+1)","v":1},{"$f":"IF(F10=0,1,0)","v":0}]
[null,{"$f":"+B10+1","v":2},{"$f":"+E10","v":"Motor"},0.79755001700960249,"Programador",{"$f":"IF(C10=\"Motor\",IF(C11=\"Motor\",0,20),IF(C11=\"Programador\",0,55))","v":55},{"$f":"+G10+F11","v":75},{"$f":"IF(C11=\"Motor\",H10+1,H10)","v":1},{"$f":"IF(C11=\"Motor\",I10,I10+1)","v":1},{"$f":"IF(F11=0,1,0)","v":0}]
[null,3,"Programador",0.28308367725828332,"Programador",{"$f":"IF(C11=\"Motor\",IF(C12=\"Motor\",0,20),IF(C12=\"Programador\",0,55))","v":20},95,1,2,0]
[null,4,"Programador",0.16097743359604988,"Programador",0,95,1,3,1]
[null,5,"Programador",0.73435378196180201,"Motor",0,95,1,4,1]
[null,6,"Motor",0.51356588607820119,"Programador",55,150,2,4,0]
[null,7,"Programador",0.90400342628073804,"Motor",20,170,2,5,0]
[null,8,"Motor",0.17199151081066,"Programador",55,225,3,5,0]
[null,9,"Programador",0.57360872961333953,"Motor",20,245,3,6,0]
[null,10,"Motor",0.51758043355416938,"Programador",55,300,4,6,0]
[null,11,"Programador",0.13357528631055027,"Programador",20,320,4,7,0]
[null,12,"Programador",0.81073834403322731,"Motor",0,320,4,8,1]
[null,13,"Motor",0.72058036171901885,"Programador",55,375,5,8,0]
[null,14,"Programador",0.35783471666033861,"Programador",20,395,5,9,0]
[null,15,"Programador",0.6645196698542577,"Motor",0,395,5,10,1]
[null,{"$f":"+B24+1","v":16},{"$f":"+E24","v":"Motor"},0.87369265168511134,{"$f":"IF(C25=\"Motor\",IF(D25<$E$4,\"Motor\",\"Programador\"),IF(D25<$E$5,\"Programador\",\"Motor\"))","v":"Programador"},{"$f":"IF(C24=\"Motor\",IF(C25=\"Motor\",0,20),IF(C25=\"Programador\",0,55))","v":55},450,{"$f":"IF(C25=\"Motor\",H24+1,H24)","v":6},{"$f":"IF(C25=\"Motor\",I24,I24+1)","v":10},0]
[null,{"$f":"+B25+1","v":17},{"$f":"+E25","v":"Programador"},0.83479682332340832,{"$f":"IF(C26=\"Motor\",IF(D26<$E$4,\"Motor\",\"Programador\"),IF(D26<$E$5,\"Programador\",\"Motor\"))","v":"Motor"},{"$f":"IF(C25=\"Motor\",IF(C26=\"Motor\",0,20),IF(C26=\"Programador\",0,55))","v":20},470,{"$f":"IF(C26=\"Motor\",H25+1,H25)","v":6},{"$f":"IF(C26=\"Motor\",I25,I25+1)","v":11},0]
[null,{"$f":"+B26+1","v":18},{"$f":"+E26","v":"Motor"},6.6577656384765427E-2,{"$f":"IF(C27=\"Motor\",IF(D27<$E$4,\"Motor\",\"Programador\"),IF(D27<$E$5,\"Programador\",\"Motor\"))","v":"Motor"},{"$f":"IF(C26=\"Motor\",IF(C27=\"Motor\",0,20),IF(C27=\"Programador\",0,55))","v":55},525,{"$f":"IF(C27=\"Motor\",H26+1,H26)","v":7},{"$f":"IF(C27=\"Motor\",I26,I26+1)","v":11},0]
[null,{"$f":"+B27+1","v":19},{"$f":"+E27","v":"Motor"},0.9850312678446338,{"$f":"IF(C28=\"Motor\",IF(D28<$E$4,\"Motor\",\"Programador\"),IF(D28<$E$5,\"Programador\",\"Motor\"))","v":"Programador"},{"$f":"IF(C27=\"Motor\",IF(C28=\"Motor\",0,20),IF(C28=\"Programador\",0,55))","v":0},525,{"$f":"IF(C28=\"Motor\",H27+1,H27)","v":8},{"$f":"IF(C28=\"Motor\",I27,I27+1)","v":11},1]
[null,{"$f":"+B28+1","v":20},{"$f":"+E28","v":"Programador"},0.15744887158216947,{"$f":"IF(C29=\"Motor\",IF(D29<$E$4,\"Motor\",\"Programador\"),IF(D29<$E$5,\"Programador\",\"Motor\"))","v":"Programador"},{"$f":"IF(C28=\"Motor\",IF(C29=\"Motor\",0,20),IF(C29=\"Programador\",0,55))","v":20},545,{"$f":"IF(C29=\"Motor\",H28+1,H28)","v":8},{"$f":"IF(C29=\"Motor\",I28,I28+1)","v":12},0]
[]
[]
[null,null,null,"Medidas de Performance"]
[]
[null,null,"% Reparações gratuitas",null,null,{"$f":"SUM(J10:J29)/MAX(B9:B29)*100","v":25},"%"]
[]
[null,null,"% Avarias no Motor",null,null,{"$f":"+MAX(H9:H29)/MAX(B9:B29)*100","v":40},"%"]
[]
[null,null,"% Avarias no Programador",null,null,{"$f":"MAX(I9:I29)/MAX(B9:B29)*100","v":60},"%"]
[]
[null,null,"Custo médio por avaria",null,null,{"$f":"MAX(G9:G29)/MAX(B9:B29)","v":27.25},"u.m."]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}